Hi, a previous thread on this form addressed this issue. http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d8e55bbf-1252-49af-80d4-71b1cf5f3c64/ I found the SSIS component at http://www.ssistalk.com/how-tos/unpack-decimals-comp-3-from-the-mainframe/ I got the same error as reported in the first link above ( "Data conversion failed" "The value could not be converted because of a potential loss of data"..) I defined by s9(5) comp-3 as a DT_BYTES of length three, but that did not solve the problem. The problem is occurring on reading the source file so the target is not the issue. I set the Error Output to ignore, and it was happy but put no rows to the target The person who had this issue "solved" it, but didn't quite say how. I have a Scale of "0" on my output field. Can anyone tell me where I might look as the source of my problem? Thanks, STeve

Hi STeve, Please refer to the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1c49e76f-5477-4b49-86d4-b2fdcadaefcd/ http://andrekamman.com/reading-packed-decimals-with-ssis Hope that helps. Thanks, Eileen

Hi Eileen, Thanks for the pointers, we have successfully rebuilt the component for SQL SSIS 2008. The problem is reading the source, before it even gets to the Unpack Decimal Component, it is throwing the error Data conversion failed" "The value could not be converted because of a potential loss of data"..) As I said, I defined my source field as DT_BYTES length 3, and this seems to be the right approach, but is not producing the correct result. I am focusing on trying to get this component working before trying a different approach. STeve